SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286344 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286344 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769800,180554,753804,176358,153435,627908,1000657,381139,5167,397140,75527,3135,563915,32516,727096,468126,603641,709974,11535,972190,806320,267725,849723,316077,661967,245349,618668,67767,643561,397816,949362,309829,190795,675009,638211,788934,121721,558811,490977,368581,14580,1006495,487454,995801,912501,382308,441720,440950,508362,396097,384193,469978,719964,806695,506226,535598,544983,432952,664550,814162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286344 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286344 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]