SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801480 LIMIT 1 [ RunTime:0.001175s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801480 [ RunTime:0.004012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79259,938297,151056,387833,328101,845837,829279,12145,362095,581691,740146,357042,862444,832817,804369,657519,644339,488086,719773,542439,210003,563595,773248,789109,297126,863404,982859,103548,664309,560272,473462,172810,576268,1014194,966973,444192,140887,810856,902276,1041149,371134,330318,969871,571510,472967,555346,78324,1046518,95544,934652,435164,608839,815740,97503,319720,119490,538173,1042411,761400,554568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003118s ]