SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540893 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540893 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911634,8878,540616,524308,961739,917915,633839,31337,214053,383504,527557,999455,120763,982460,925777,1000741,914605,870090,964988,651102,685282,94431,421449,499872,839618,589856,194908,85853,473783,737329,747814,192601,1001083,358961,666738,646686,43645,417857,689538,244042,326275,92669,798958,560658,299953,453519,768765,32414,868099,748708,500133,574965,1037792,1028677,416909,726361,252321,258247,774811,431495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]