SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380304 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380304 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227259,194125,351714,698422,586687,519407,844344,986899,300898,447462,129824,536457,582220,17590,592274,3869,140728,1048233,276479,491219,177882,406615,689273,952280,312172,54775,466341,910347,240360,317987,213637,919139,409240,347330,683570,969471,826993,578630,911767,429131,782087,952631,957870,257502,180633,203569,335953,938114,65572,272201,247334,550946,165345,668268,741810,288897,969881,886362,75658,971387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]