SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414923 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414923 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192118,799529,638430,786617,715625,689603,469963,141422,735679,619994,1002971,519968,473120,389958,440462,35015,484962,582589,328543,76272,772611,261124,664889,433130,992693,547548,904040,336747,191349,857689,548949,813591,1033802,661460,144569,523556,927476,468983,532664,16331,942656,204174,439964,61271,809330,605044,333181,403779,610775,692527,190990,320162,494234,92681,500855,614553,1019711,907316,414666,1009921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]