SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510538 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510538 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411303,251040,982528,374204,1030685,166901,685601,198982,408347,631232,639857,789900,520466,707778,323241,346516,1011128,1017844,109601,821324,411983,6540,325995,608827,622309,78885,84302,118264,284574,277468,138753,648033,369139,232405,1021956,967894,217287,805652,1001181,39010,122189,258695,917394,75498,926251,125673,266585,285467,272970,444320,56232,187347,776752,751133,472522,981135,11749,301779,929098,427258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001149s ]