SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001727s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503794 LIMIT 1 [ RunTime:0.001792s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503794 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963299,520861,908962,78836,327442,754462,598568,112695,63355,925486,114948,361985,500318,215999,848767,313243,207568,925279,187511,123466,904373,798011,70273,636608,892878,394483,431909,939205,179127,779036,890871,835150,861555,247573,293415,126825,137856,149529,331020,1017053,916071,945176,609793,628290,522021,78615,398117,1029556,684734,500766,518559,988627,585775,408345,886915,650174,801717,635230,699394,586776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]