SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513481 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513481 [ RunTime:0.002250s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233789,260803,80494,266832,527948,830730,712516,866560,819651,412186,478742,106534,795734,14131,485315,115858,1031555,842173,92715,248812,383898,801885,748825,148410,988907,880646,8621,92282,901921,946280,540276,272405,223920,946353,343909,239203,371062,864814,434771,995914,75664,443099,510103,440654,533233,696006,728169,253064,355878,380773,1001767,439413,707916,182665,121079,850348,809736,794664,577160,657319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]