SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54848 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54848 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483873,700315,322361,534149,805987,51445,255592,705673,578043,868491,929599,747412,728537,142999,199152,598145,702423,535883,620310,523545,137122,787013,468277,967510,36148,550704,298528,259084,733212,693864,116178,520468,142849,137665,765098,364898,448913,93585,900764,718966,240228,803662,148121,410350,268546,776069,382976,848684,480230,528304,528453,1025310,119268,722167,422148,410658,1040627,759430,545521,233342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]