SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005770 LIMIT 1 [ RunTime:0.001177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005770 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361746,114481,979523,773305,675283,689394,561832,267969,302343,976332,954907,934399,566708,944176,886670,893802,640170,232193,100940,788134,822343,1005058,281450,551992,664771,16781,1040527,329544,469250,640385,197322,190530,636372,170302,244001,287034,226531,502563,1013332,813196,82757,83337,952565,622172,964866,622894,941929,93363,313824,792134,884611,60709,438417,666075,1034774,833444,889035,1002695,826336,129084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]