SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204981 LIMIT 1 [ RunTime:0.001552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204981 [ RunTime:0.003461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862079,1047433,604590,802436,677932,312717,202193,1038901,1043869,200696,432313,894573,794246,417240,784352,875532,1023533,139366,819427,982412,527561,373872,537889,50405,1015014,716996,206879,159636,178748,454252,788178,655136,475649,670941,1045342,169228,463362,14811,892947,188312,129496,733129,73194,86934,409164,40362,188958,917935,505916,959992,255574,455492,282240,712987,533679,888746,932326,504435,44467,640082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001659s ]