SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198204 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198204 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612743,414407,885507,653672,313936,722173,981204,387248,182116,713548,633017,802003,946844,249418,353882,817369,977147,489900,520794,846434,401596,734605,265975,719432,616132,64355,363280,18409,931705,511356,399070,531488,6402,80614,645302,156608,945118,803868,220456,12866,118836,549180,184322,824172,378102,595399,844653,235280,795104,1009515,885178,799776,517901,1037447,715425,592224,332411,1018712,245968,316332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]