SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803528 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803528 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687201,710760,624818,390744,1011417,867210,28520,393837,401454,838344,207457,757632,215053,133659,341950,614789,370002,59591,41326,53161,799254,826769,903490,577148,79713,806945,556454,107076,127776,310100,980378,756198,775719,644808,965706,809816,993961,971850,244974,646268,646720,970172,1003127,480561,493848,219142,264963,988461,541059,371587,646525,910390,878940,166182,84529,487394,948115,869083,1034112,868022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]