SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028963 LIMIT 1 [ RunTime:0.004099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028963 [ RunTime:0.005659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518629,302595,400297,112878,449756,637975,353929,647847,922049,661710,459699,759039,439373,532165,547194,745544,524608,700185,691219,956290,920789,388,426040,980896,916636,880431,57383,683554,165451,192356,743230,413983,165496,453457,809556,460272,674014,5940,360981,468136,513123,446574,390389,406447,822727,267589,562786,542010,469893,885677,811602,146493,792695,934280,82379,685556,84678,433541,803981,480733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]