SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 371020 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 371020 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198614,491474,879406,740810,524046,819866,1038046,189180,121183,664734,187016,32045,958649,529755,339021,999174,507345,741298,828599,846241,252815,116180,975767,896082,266997,701425,379448,470300,630158,399188,124021,4608,180860,698949,506790,866490,852042,820468,910163,225100,948861,1008613,750370,754151,1014224,196117,812532,607966,573259,1039893,573784,342088,409416,788353,816830,447817,954356,176774,820875,635278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 371020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 371020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]