SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004731s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 360027 LIMIT 1 [ RunTime:0.001190s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 360027 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003132,1018078,259795,304383,8833,451843,138818,121581,844491,781688,549882,841351,44789,545482,278914,400499,420024,790988,425780,354138,437815,576286,729396,739673,1005138,725044,829464,328410,450827,628133,686714,433055,284866,338918,470737,838038,223277,639051,456025,448190,12994,1038714,324402,551705,938689,356246,752295,601411,701108,127757,355661,32887,804144,852518,395662,1015759,718892,778122,466916,612143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 360027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 360027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]