SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506540 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506540 [ RunTime:0.005254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642228,562485,539099,1014539,18950,877746,146571,661073,796266,250073,949437,44381,595466,911010,555953,650635,603407,847376,387771,676747,526743,229196,717829,711071,562848,254384,145045,32796,795309,458394,58976,526291,148207,459195,404283,722169,270812,835940,611457,276509,991052,914191,620367,300623,738587,69856,815392,658549,884156,929545,791662,176492,525856,172551,135243,103132,785990,960465,346425,15688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001233s ]