SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502694 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502694 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776498,840388,712911,906062,136163,295338,825888,4404,863290,872953,805098,1019850,296643,582063,348170,628450,814209,259352,356623,922934,556883,7477,361830,229804,612701,882473,410387,565101,559896,722267,786570,907294,804150,167990,322597,684100,972914,663706,1020377,501494,635937,488050,394956,151275,288776,135285,866717,1017648,936475,783957,709492,394895,849482,505793,298411,716774,236956,932474,462197,220422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]