SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267656 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267656 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181031,228915,825848,370253,233048,1016319,921018,167602,981677,68618,10335,343741,752921,28784,240097,594952,178618,921184,475074,1002135,160899,332303,282672,133056,329415,503995,667381,114220,686426,749540,501964,200947,31712,587393,283569,325657,361306,305174,88869,517104,185053,444299,201618,210531,339979,20023,900372,270908,930535,464095,864825,689415,709325,201483,799399,267913,329086,1017040,395723,157937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]