SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594963 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594963 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813682,1017076,114405,233957,904004,161266,415499,51881,22626,264584,994253,816112,155207,125996,17103,308951,237241,653443,315374,368323,268954,985897,466231,1043405,11097,592939,568421,809915,494194,85000,447093,274146,667317,1047130,540990,138980,141627,365782,471380,64858,46898,906396,698450,192369,912092,297132,722968,880708,693327,552817,270904,995928,195334,600393,44323,917425,963825,363459,197530,932474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]