SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014316 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014316 [ RunTime:0.003781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625027,570924,493864,185944,552649,996602,789248,339090,772524,580896,651910,61165,279660,788245,433502,343023,1001503,287542,463026,786633,15046,838099,1019512,528264,954063,798280,149539,693779,671522,608718,475169,97284,930181,31724,517329,365165,720308,808753,866019,264911,984830,422245,975114,148318,83507,438010,675245,849611,205715,737801,874499,442615,404616,237545,184375,479594,91254,781809,559437,794449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]