SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503365 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503365 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031005,715554,457704,1161,18258,531850,12330,912321,455687,738633,717524,260585,19131,1030017,386128,801227,256680,692198,379246,231500,331334,1035936,159477,2693,417919,315360,608621,55372,824135,208752,235202,353530,149416,46341,54617,810128,83787,772099,785990,580383,1019403,586705,209255,667895,409871,461386,1027395,542866,715494,651916,913056,826046,1035447,47526,1047474,269298,173801,264897,310018,565031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]