SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503192 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503192 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695921,819347,388355,349541,974349,369448,694798,536379,70763,612896,51399,638894,1048074,519552,460130,915160,740553,493525,233714,961163,138175,181400,676229,800991,282820,200315,327990,247042,713322,287491,710892,8915,110263,984423,395560,5554,495885,315618,308839,333933,980235,727087,796405,3117,350657,197087,447485,239939,627644,945862,129847,285451,505257,871631,352341,922426,31156,159859,698712,1023300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]