SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419620 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419620 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255345,640425,67113,1013897,64748,818802,673673,272702,360129,990439,734245,181660,549760,1004979,211927,642009,311572,737012,1041715,539289,266659,669399,62779,736670,709792,579376,1009724,670680,121231,76513,352365,185854,838187,524567,417433,140038,614850,104978,333248,10402,1022630,61548,199710,358435,87420,51473,121115,485178,75985,469590,572984,256605,237204,605618,248511,713253,752754,258514,932785,444959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]