SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013147 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013147 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662156,832795,8257,831530,122425,534233,648176,1048450,958307,510141,4506,112425,309207,200702,623672,258024,814020,12987,552198,763697,119835,907805,929937,1046485,479773,1039171,480964,6073,408972,461151,399520,791796,108289,134588,764748,785860,971354,379854,38190,253710,398886,597707,10056,452515,1040410,326540,602744,746700,1015650,196388,806352,95037,461307,550995,645549,1041440,735256,127682,924094,995577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]