SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457268 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457268 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121290,139960,412575,321961,581769,688372,753817,109547,554442,881079,781779,403168,49230,529145,82747,471772,570664,614301,645508,877981,1026248,178063,603753,543149,480951,618075,544814,746003,6078,336863,270289,35721,245937,750455,426079,494475,584185,530371,824521,669924,425380,217454,261759,481599,466066,645183,11053,1021902,765053,203705,954966,337272,1045671,40877,778260,471170,87150,396327,444837,130722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]