SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808718 LIMIT 1 [ RunTime:0.003034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808718 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518925,360789,107868,681447,828974,105409,585109,488718,253269,31392,552529,655678,784332,936582,127296,534085,122807,243331,483668,694038,339784,827217,880938,106650,390062,285345,813545,204503,736515,108545,1018366,933686,609604,308248,669005,105413,436107,35256,162434,1034796,701719,1046414,852616,188621,523240,841206,278320,140867,410644,324148,991223,702093,678065,488344,298999,1015612,135534,938512,793127,958899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]