SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106037 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106037 [ RunTime:0.003430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201359,715733,233752,139465,545306,774950,1013250,682294,433967,435720,929924,658424,201794,1033818,137637,94064,321874,427573,360752,433961,231393,42007,135495,651851,166886,36580,886252,1005298,776798,572728,221945,882979,114174,115793,516701,933436,727304,778693,502867,272243,252423,688554,1046764,191958,104365,206283,281800,259573,174385,572351,171689,1027920,765545,968251,941589,668099,119512,838220,904075,290349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]