SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034980 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034980 [ RunTime:0.006216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181945,848371,261170,788971,874027,246485,323046,80179,946823,402632,502930,330129,706469,55253,880782,840209,849381,283254,657608,267052,610584,832177,325585,591202,435838,699584,992336,86434,752522,291569,920203,579514,94432,193520,877746,113572,169611,273581,190293,728748,635248,517361,707880,1043857,273428,623422,144890,138646,565705,983295,405272,365067,718362,615579,427485,32686,1008625,678778,594788,814449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]