SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534165 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534165 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90876,1032860,452615,850836,240849,67184,301155,903323,71407,758501,422732,678523,936154,990891,855969,1043984,731799,390112,548360,609959,1017629,770498,1044269,892291,28689,705987,158400,588663,740212,568197,800761,795650,421277,331792,459394,436832,361309,480182,714190,233574,325339,889563,763102,708413,383710,320573,163161,61990,799279,939188,94120,848601,44261,617996,867367,764511,571935,17695,114083,775406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534165 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534165 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001246s ]