SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180713 LIMIT 1 [ RunTime:0.001713s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180713 [ RunTime:0.005397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012018,101512,925234,610522,253712,670291,804277,834902,333959,337108,59190,913801,74433,705250,446811,652556,37036,68101,122087,964181,607434,731734,250652,171384,778458,658662,67743,633272,793484,393896,802004,424558,970589,962895,547954,662201,1011786,1003563,829965,102923,505770,216307,665859,449823,140058,49048,30608,325811,1012844,1038822,122615,259797,986468,655530,236061,129378,240876,784385,185790,673280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]