SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172710 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172710 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428875,354554,980061,70498,833987,545495,161837,634790,1002040,40370,853528,532999,924555,776377,855792,852929,240087,684339,119226,859716,674167,904313,729151,607996,622358,892911,1040355,752049,725848,586156,25470,675199,447423,80884,10074,407802,956825,656669,805982,1015014,592884,222209,925577,1041202,130690,451400,101008,912216,232461,225923,953626,659594,89614,206021,628175,444906,365660,296860,181916,553063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]