SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427063 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427063 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002917,259410,737661,126004,395369,189926,1000583,272322,396742,657829,424416,1013328,875921,920978,25819,521947,368811,172950,298310,453236,697142,895377,416817,714817,529793,664307,294467,17424,923622,918874,403732,571,182621,1026370,63461,443681,683157,534430,859071,211288,486974,420929,82601,671580,21611,474423,231616,873598,230819,175834,426381,323719,231299,1035552,828907,179681,286597,50892,669750,453961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]