SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 94110 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 94110 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234674,250955,850030,655072,746612,120240,410241,984720,540258,459795,998566,113013,980159,148533,998868,33710,748922,283282,1012405,36789,635945,699368,741139,316196,541036,627312,391441,252265,674552,922723,136479,377324,331034,316680,702016,271101,967676,336027,382758,336008,45441,363914,684372,381226,930988,294918,894126,884656,979001,972809,246837,594305,478977,319034,840767,3061,404420,682574,14463,533108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 94110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 94110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003540s ]