SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006970s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026543 LIMIT 1 [ RunTime:0.004155s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026543 [ RunTime:0.005029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793303,732301,637642,716917,195540,652124,691513,335173,987018,431134,1037977,885506,188664,601996,752598,418423,998477,67614,774377,405751,127311,731432,611574,936504,447528,980337,685303,261720,694447,235873,932469,55382,827919,700147,60546,662138,763325,80054,979757,360186,652297,473868,512186,837791,278213,382368,500470,738600,401975,68987,53643,592667,590515,928540,911411,300903,141150,483662,114874,106698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002442s ]