SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291775 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291775 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784999,440526,774281,942629,730264,348736,398438,77911,976812,207859,746213,840474,363483,267152,674617,1037937,415613,891549,574452,447363,733838,699209,840211,713319,768498,801050,771584,1021895,872439,142732,356338,824472,216800,484568,359928,607305,26963,130996,335993,454826,479140,61844,1001373,101393,912768,106696,1000937,336439,740872,563702,255071,180387,707347,201222,647489,994024,6731,716550,969803,133936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]