SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240873 LIMIT 1 [ RunTime:0.003974s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240873 [ RunTime:0.006003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428239,248951,151807,567005,776598,461076,809202,542006,980185,720899,125364,52489,413061,868768,586685,70633,563061,54723,874061,424421,369398,788508,394608,838301,87599,697998,1028300,372324,271343,472210,605535,504483,520536,637743,27996,1043244,580337,295201,297652,322739,801066,178632,87425,770456,1010586,938561,981627,212214,763577,94174,372712,956023,288407,775930,221818,247127,716553,783492,966781,678386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]