SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544216 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544216 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553912,670689,741733,18558,493135,435419,886621,384393,1047988,812773,724914,680980,541379,221633,30675,70318,307128,694771,584602,998011,759178,210839,373596,466056,735187,722417,728305,185721,904788,406705,12193,525095,167105,76562,12315,54105,766148,802933,960819,869552,28583,19631,844906,66500,39033,302470,1005484,531829,470294,125627,702862,242481,906153,916287,733468,458159,236249,805131,756823,831222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]