SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316843 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316843 [ RunTime:0.003280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623149,140395,344344,691417,729232,109218,884004,841597,521068,816330,531438,35523,955992,979716,579859,841316,482658,121211,293280,943970,104926,99789,933932,1029587,88680,730516,804807,313860,284712,469372,495356,662442,1037585,259112,238862,847429,606869,650638,319080,93152,925529,227395,946681,1006667,186669,190539,1010221,330841,1011463,708456,167239,992864,413711,872230,782090,459344,79673,636325,752019,744554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]