SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610422 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610422 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117712,367160,247840,907018,885040,292950,169619,790799,239340,594474,391252,876903,809119,152419,157703,870617,151072,748145,695427,565247,1023411,487704,542019,933440,254296,846893,628196,355658,378001,759092,307719,471899,435082,914705,37923,995947,339275,424275,332886,779309,901908,162893,134886,656584,742144,667907,446773,560368,488318,324083,325189,935662,681916,173029,207550,346983,173602,38986,365294,968354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]