SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386180 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386180 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391782,145115,398268,825779,138683,316291,948306,809683,943658,701168,130090,260921,314177,760106,580251,596088,212951,832653,959648,756488,1038682,672240,850865,919661,978964,439852,822516,64234,911026,607534,896759,258868,366692,424148,726814,214493,425097,1047937,447244,977200,515886,668063,42990,405202,267032,1047165,196334,412914,418528,856785,40088,167137,909645,421221,230726,608034,789597,971841,231803,535710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]