SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319554 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319554 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124599,42552,388737,155188,406547,636857,310552,795852,999282,820834,3721,558605,138765,776221,861250,160906,427595,100099,181491,513402,86840,650923,263815,472961,312711,781880,309053,743145,212927,822847,990340,756935,178866,540824,765813,510648,371362,248420,520721,429927,254296,410979,35641,678115,12989,485435,554903,215684,286215,203264,148287,291589,368438,10096,1002955,793981,569952,382375,2964,128121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]