SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027230 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027230 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874888,300489,704717,3215,104083,1022752,5067,77628,495876,755457,586780,350971,745858,249490,949211,1046511,888482,925450,454412,427193,789270,633530,491327,63575,88484,496076,903277,210521,471482,350655,337811,759390,609712,481766,1042588,818848,555417,548981,382242,806791,878080,840824,29844,195011,758874,621529,636021,108027,781104,8426,222346,105924,195456,424367,233776,994847,662356,351173,297909,528898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]