SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402656 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402656 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147320,1017945,1027971,554282,166587,751783,962447,937989,750326,325528,413799,605988,121494,777769,907830,751554,625929,558029,984665,838364,1045061,573794,677357,321721,624563,701539,1019112,914570,44293,390472,1024161,1018551,752255,709868,300533,807440,963413,372320,122212,462089,404705,340083,658680,873120,523690,762153,158092,421053,458539,409628,427505,680467,177198,804725,147291,197319,813770,536932,943933,257928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002420s ]