SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415641 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415641 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435787,945112,71583,534250,282763,836885,442378,808456,442819,666985,656663,251791,166307,875202,435549,219571,520210,421171,257376,680743,710004,58966,33144,465076,99982,325396,712358,374047,999234,632589,791139,239725,145623,747250,258760,280002,271774,733324,390314,725744,635127,514025,773710,438557,811248,1043675,694760,412200,111862,81867,693009,487164,644894,143418,716125,278502,798306,228857,447951,288891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000911s ]