SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631204 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631204 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194086,193614,488246,1001917,594434,481360,133612,505872,542409,866862,193256,482173,552119,517322,638694,319298,1036591,605664,741655,358155,495634,401234,680354,1007794,131514,566967,872783,896067,304023,418603,696504,280225,142859,476219,707028,417721,22963,480043,487230,845064,432978,402609,151236,514411,54211,808435,392955,519583,494777,445392,502526,339660,266638,699959,193245,305591,887596,702680,979769,436451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]