SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453518 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453518 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423250,544875,350528,507296,766448,480019,1022491,393534,842647,555469,979407,668348,281827,997066,564665,633675,448778,141767,460962,424677,777771,153758,165047,607243,5361,943826,646604,802812,850491,841438,551362,707526,464285,1018253,284692,799536,341634,644068,482144,530154,23735,176792,114703,682871,455613,692921,181109,234361,235644,202075,53499,261860,971054,804437,331352,461337,420769,633250,97154,896952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]