SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483171 LIMIT 1 [ RunTime:0.000752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483171 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226180,982352,503954,249842,661401,26888,736303,448543,362234,197068,192810,669318,998995,113710,1021433,745818,320236,67967,205680,537986,424365,930202,1028941,851476,420265,917218,332569,774615,620803,649861,38151,938829,358910,586368,833173,815307,675470,813358,468476,614618,36678,751292,777674,956600,474596,518922,758423,862749,986778,158695,387090,748451,749347,215121,331483,184242,344418,536210,175446,534510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]