SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533410 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533410 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834293,328465,1009639,730109,513856,438231,865380,162084,912290,759400,1031514,951237,385679,800729,851302,862241,1000076,887228,665404,481922,693051,806271,106941,845294,458480,475308,674688,800067,920453,307059,562182,289139,870701,193722,442522,792885,1007152,79836,502956,496446,281105,895768,457872,979063,525019,903142,791287,777864,95071,566681,653683,320480,642615,388385,244306,655928,959089,849200,983323,628252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]