SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286389 LIMIT 1 [ RunTime:0.000689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286389 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789832,1020053,48348,12582,692616,1011127,537383,630471,202439,676565,509628,599728,969996,1000944,555505,148814,757655,633111,16004,120406,415034,443917,741936,415253,419026,390703,372291,942857,381886,1030066,251582,747685,68719,67198,1022025,158406,189048,177817,1023330,349586,459784,272697,336107,233829,618191,29516,333768,672247,706082,644950,406002,911440,586973,439261,419987,440935,888213,1029531,267578,74141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]