SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502870 LIMIT 1 [ RunTime:0.000665s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502870 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39574,825032,1033745,993162,749275,279931,426512,559913,387987,1029600,524202,992468,689305,503030,829438,165541,221701,461432,828178,979209,141908,181223,332859,217501,187943,286235,785276,131756,436085,76403,839864,524341,669381,111053,580259,976731,982962,379213,113135,81813,398496,264088,951354,107689,598374,346836,312298,125359,542247,564424,867527,899691,728876,90167,22824,603599,399187,811960,470803,416448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002744s ]