SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574251 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574251 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829597,828634,1023872,761591,814799,802672,73239,775992,641030,147708,877016,388989,328729,851935,65047,429709,208608,222658,705768,827540,54537,144100,353584,1041552,134101,679619,365209,466818,789457,141077,691987,242824,817480,140965,426471,902560,1014328,185215,76289,553622,228774,545600,688682,318844,791798,98278,486424,840190,600892,161145,1016876,635160,759304,204763,631999,525135,453044,970350,587075,31583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]