SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005421 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005421 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416553,295622,936394,239699,280237,975925,235712,870898,875325,323952,611312,479351,803298,862149,882181,731851,430753,282237,439998,81168,635406,871827,248203,449322,883734,237612,998955,37411,1015617,947147,581212,421564,316291,862084,106064,388672,407002,754091,747660,426486,382672,235740,204427,560314,230204,336448,781132,378965,80357,567444,996792,172694,911840,234366,314153,224480,245667,326448,210825,7343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000889s ]