SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267218 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267218 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334011,207519,429558,132525,983888,978505,194191,576231,129061,788211,618345,417878,285095,389806,224495,255871,240736,167862,567236,679118,1032335,633985,689372,870142,770866,77322,833342,721474,534847,791791,874441,416217,79722,474947,27903,744444,343125,953062,840088,321194,178564,370442,333361,1037755,229282,198392,172988,641837,309039,645707,18260,31306,52920,134854,609728,661630,994733,85771,170840,596521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]