SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104591 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104591 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403169,75763,739986,208664,456621,460906,902443,351325,291708,703246,807566,1002491,360324,913066,385921,118391,457621,719692,111037,621393,175249,644836,6433,928950,494326,308240,672180,716366,703758,427595,332180,473767,263101,121299,970665,410980,915029,34193,1037662,932693,924114,31238,568120,869134,194797,642903,204931,257029,143953,540651,78575,527843,645131,148781,537974,152476,960128,666835,859683,776700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]