SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454193 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454193 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310530,507853,320816,616445,398312,369618,928394,242014,659267,369459,949643,259714,106170,818975,482292,944019,486060,1014392,328206,187845,448017,951030,584596,31358,155631,570283,424170,961292,366437,953797,167926,848784,33054,520262,265563,464483,200613,829252,525416,761226,423446,119721,404992,8926,915859,417451,302679,613257,311060,768636,635150,418351,870799,151193,429887,606368,522983,813893,653151,335081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]