SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260881 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260881 [ RunTime:0.003555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374302,533191,185445,483785,820312,770612,384675,641481,245952,853368,679566,557896,357584,694616,968191,804230,579056,309211,327430,413730,696554,635150,444759,580076,910913,1018925,849203,783935,578662,766413,42892,130814,973157,124204,110317,801705,510028,22069,685896,537034,850364,795326,936926,853555,584996,347425,188000,846028,661385,169889,982500,677677,286191,684071,809633,51835,926911,943379,315348,408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001216s ]