SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328511 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328511 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576012,1002448,750855,16001,735408,167063,686006,481874,338791,326019,856048,885551,107981,212182,472241,563852,306410,506893,1039895,380584,448372,256964,324874,629195,17328,413560,911447,752561,1015727,363726,172068,457134,793952,587275,730129,139153,527467,239180,978302,425881,417978,457873,943367,404193,1027908,573035,568325,621288,837830,334517,339663,572326,224712,867532,531110,984731,604142,213863,399589,624017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]