SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498936 LIMIT 1 [ RunTime:0.000977s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498936 [ RunTime:0.005896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862337,354976,246379,611566,933102,891034,290240,132085,762597,175531,249037,138799,40207,907114,547447,416869,1012673,804198,233124,250147,572247,95426,670458,882597,520931,1020495,942903,877867,850263,889555,1021620,862824,25932,1007552,293112,458551,1048522,105034,442757,212156,191400,788182,764344,980861,823694,451802,138575,633644,642503,244357,522849,18439,752340,952707,44336,237626,341689,322424,244072,694380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002927s ]