SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505253 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505253 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934602,762052,309373,1034844,233050,1034800,350405,3666,522812,818023,217675,943524,942089,404937,347342,479335,43072,339751,100067,1027248,802611,805539,231759,232381,156234,823721,55298,817537,928225,843577,46895,126750,655026,131120,49680,353118,582544,40730,871336,559597,283922,375703,779292,821249,980205,179453,252213,43809,1035222,608761,796517,968484,851346,778934,789853,468534,518707,87502,289173,811402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]