SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405890 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405890 [ RunTime:0.003535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737130,318517,484485,1039777,919178,845260,662713,565255,150112,33995,1048859,492987,1037526,939006,466228,769916,1032360,535390,213529,471083,303505,913882,780626,356993,213709,378570,1033437,976462,418075,573215,238376,892851,865119,303809,579707,876095,160351,451462,240548,883730,951422,51978,65995,346503,997798,538806,931053,67868,580249,859019,395673,693316,22735,810195,389774,636842,93730,554013,598111,253097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]