SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395041 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395041 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336943,844542,583363,236584,361326,806713,1034630,793212,810382,720398,540230,763993,361410,383624,785508,335330,148522,1033739,123692,649044,475503,52066,488274,1044098,22098,807773,129095,1021861,210610,1005547,100010,627173,251076,1000074,689913,407792,887452,75542,617917,955298,705827,901010,539274,117165,1041995,61277,172212,484338,726019,197174,581070,180500,249026,139839,213771,559560,933002,670662,495248,346266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]