SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58570 LIMIT 1 [ RunTime:0.001544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58570 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157533,164354,1036876,557612,437764,365182,275789,807955,689087,739773,788306,334797,404494,79762,252226,403407,62380,401353,549911,980052,116754,979576,231383,783898,92030,288652,688398,910051,919058,507227,1037269,1008323,5414,337484,861942,312876,304717,33497,1017565,703250,608795,413674,490306,1032653,93693,972128,247675,471077,177782,858424,483988,731562,417174,158879,950923,445408,38823,120959,1044975,507400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001783s ]