SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518843 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518843 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493370,176722,900010,244904,1026130,359037,919839,394061,338768,243009,942941,203358,844206,816570,108720,2580,152867,116362,78395,773232,297242,133771,25597,474886,515734,289458,758263,569247,678477,71213,37004,183094,336627,863868,416033,771889,596911,988219,155297,700274,46551,74975,382852,127255,70838,556699,15111,22618,651148,200611,519022,20251,783561,181203,475779,306258,238179,580517,281767,988075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]