SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504184 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504184 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656264,500956,669688,429547,344734,723963,1002213,86575,93250,572624,133916,802864,136476,1047661,817497,1005342,189302,19234,737458,106285,888905,836909,531369,1005755,500008,428072,272161,624122,785749,735134,304122,2427,103327,32619,972002,637491,60336,508505,977087,700944,775585,311337,905801,224857,18585,918339,714936,672421,138431,201061,777167,1013766,558463,548065,421971,537249,710284,561338,951336,877411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]