SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504710 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504710 [ RunTime:0.004283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611402,591046,583405,501047,251333,241241,607747,201716,368460,974559,502553,944939,717761,371901,466369,210818,126326,545265,418818,1033947,758334,572104,118163,397829,499673,229934,918869,706796,771152,160712,634179,124076,94467,35524,280255,1041019,574843,796191,468596,704063,543048,354038,670076,574232,752641,431237,865637,581509,1000359,750683,463931,153163,832535,818291,590326,138017,376922,391105,93180,813264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]